Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

File_SettingRead + File_SettingSave

Reads and saves settings to Settings file, used asp here. Similar to

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

GetGroupMembers

List All the Members of a Group Needs GroupNames text file having list of ...

GetGroupMembers.zip

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

ExitTool and DoNothing

My way of Exiting tool in case or error, also another sub that basically does ...

File_SettingRead

Reads setting from config file Config file can be passed as argument ...

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

DB_Connect_Install.zip